2015-06-05 - 19508.200 - Spec - Japan ARUN exception report #CrystalReportDevelopment

SPECIFICATIONS

19508.200 - Japan ARUN Exception Report

Requirement Summary

Need to create Japan ARUN Exception Report.

Admin Info

Purpose
 Need to create Japan ARUN Exception Report.
Requested By
 Junko Ueda
Spec Created By
 Dhananjay G
Spec Created Date
 06/05/2015
Spec QA by
 Uday Kumar P
Objects
 MAKT and KNA1
Document Status
 Complete

Estimates

SNo
 Activity
 Estimation in Hours
1
 Research
 32
2
 Issues & requirements
 32
3
 Documentation
 16
4
 Development/ Config
 40
5
 Unit test & QA
 16
6
 Crystal Checklist
 08
7
 Functional Analysis
 16

TOTAL
 160

References

Prior Tickets

None

Documents

None

Spec Changes

SNo
 Change Details
 Requested By
 Requested On
 Notes if any
1.
 Report Title Defined: "ARUN140 - ARUN Log Exception by Material and Customer".
 Christine
 06/10/2015
2.
 Finalized the file name "ARUNEXCEPTION.XLSX" to place in the production folder.
 Christine
 06/10/2015
3.
 Created the location for accessing the Excel file: \\10.115.101.38\BIUserdata\ARUN.
 Mark H
 06/15/2015
4.
 Added the ship-to and ship-to name to the report drill down from customer.
 Christine
 06/17/2015
5.
 If the ship-to is blank please populate "not assigned".
 Christine
 06/24/2014
6.
 Replace the quantites sum to count of the exceptions display in the ARUN140 report.
 Christine
 06/29/2014

Functional Requirement

Purpose/WHY:

Need to create Japan ARUN Exception Report.

In Scope:

ARUN Exception Report only for Japan region.

Out of Scope:

Other Regions.

Solution Summary

1. Need to add the fields like Material Number, Material Description, Grid value, Exception, Customer Number, Customer name and Quantity.
2. Need to use the data source tables ARUN Simulation Excel File, MAKT and KNA1.
3. Need to create the subreport using MAKT table for getting Material Description data in the main report.
4. Need to create the subreport using KNA1 table for getting Customer Name data in the main report.
5. Need to add the suppression condition for Exceptions i.e Quantity not equal to Zero.
6. Need to required fields in the ARUNEXCEPTION.XLSX file - Plant, Material, MRP Status, Order, Item, Schedule Line, SLOC, UOM, Grid value, Sold-to, Ship-to and Quantity.
7. Need to add the condition that If the ship-to is blank then report should display 'Not assigned'.

Test Plan

Test ID
 Test Scenario
 Expected Results
1
 Report Format.
 Should be as per NEC crystal standard checklist.
2
 Execute Crystal Report in Crystal Designer tool after changes.
 Report should execute successfully in Crystal Designer tool.
3
 Schedule the Report in NEC BI Launch Pad.
 Report should execute successfully in NEC BI Launch Pad.

Solution Details

1. Need to add the fields like Material Number, Material Description, Grid value, Exception, Customer Number, Customer name and Quantity.
2. Need to use the data source tables ARUN Simulation Excel File, MAKT and KNA1.
3. Need to create the sub report using MAKT table for getting Material Description data in the main report.
4. Need to create the sub report using KNA1 table for getting Customer Name data in the main report.
5. After completion of development the reports need to be saved and scheduled into the BOBJ Development Server.
6. Need to add one more condition to check if the Quantity is Zero. This will fix the issue of exceptions at order level and only display correct material level exceptions.
7. Need to create ODBC connection on the BI Production(\\10.115.101.38\) for “Excel 12.0 Driver” for using the Excel file(\BIUserdata\ARUN\ARUNEXCEPTION.XLSX) by NEC.
8. If the ship-to is blank, need to populate "Not assigned" in ARUN140 report by drill down on Customer.
9. Need to required fields in the ARUNEXCEPTION.XLSX file - Plant, Material, MRP Status, Order, Item, Schedule Line, SLOC, UOM, Grid value, Sold-to, Ship-to and Quantity.
10. Mockup of the report requested by NEC is shown below:
ARUN report.jpg

Issues

1. ODBC Connection of 32 bit was difficult to create on 64 Bit server machine.
2. Ship-to blank values need to be fixed in the ARUN Simulation file.
3. Sub-reports were used to fetch the Customer and Material descriptions.